Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$BUFFER_POOL_STATISTICS

`V$BUFFER_POOL_STATISTICS` displays statistics about all buffer pools available for the instance.

Column | Datatype | Description
--- | --- | ---
`ID` | `NUMBER` | Buffer pool identifier number
`NAME` | `VARCHAR2(20)` | Name of the buffer pool
`SET_MSIZE` | `NUMBER` | Buffer pool maximum set size
`CNUM_REPL` | `NUMBER` | Number of buffers on replacement list
`CNUM_WRITE` | `NUMBER` | Number of buffers on write list
`CNUM_SET` | `NUMBER` | Number of buffers in set
`BUF_GOT` | `NUMBER` | Number of buffers gotten by the set
`SUM_WRITE` | `NUMBER` | Number of buffers written by the set
`SUM_SCAN` | `NUMBER` | Number of buffers scanned in the set
`FREE_BUFFER_WAIT` | `NUMBER` | Free buffer wait statistic
`WRITE_COMPLETE_WAIT` | `NUMBER` | Write complete wait statistic
`BUFFER_BUSY_WAIT` | `NUMBER` | Buffer busy wait statistic
`FREE_BUFFER_INSPECTED` | `NUMBER` | Free buffer inspected statistic
`DIRTY_BUFFERS_INSPECTED` | `NUMBER` | Dirty buffers inspected statistic
`DB_BLOCK_CHANGE` | `NUMBER` | Database blocks changed statistic
`DB_BLOCK_GETS` | `NUMBER` | Database blocks gotten statistic
`CONSISTENT_GETS` | `NUMBER` | Consistent gets statistic
`PHYSICAL_READS` | `NUMBER` | Physical reads statistic
`PHYSICAL_WRITES` | `NUMBER` | Physical writes statistic

See Also: "DB_CACHE_SIZE"